| Server IP : 121.121.20.254 / Your IP : 216.73.216.202 Web Server : Microsoft-IIS/10.0 System : Windows NT WEB-SERVER 10.0 build 20348 (Windows Server 2022) AMD64 User : IUSR ( 0) PHP Version : 8.3.28 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/Program Files/LibreOffice/help/en-US/text/sbasic/shared/ |
Upload File : |
<!DOCTYPE html>
<html lang="en-US" dir="ltr">
<head>
<base href="../../../../">
<noscript><meta http-equiv="refresh" content="0; URL=../../../../en-US/noscript.html"></noscript>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>DateDiff Function</title>
<link rel="shortcut icon" href="media/navigation/favicon.ico">
<link type="text/css" href="normalize.css" rel="Stylesheet">
<link type="text/css" href="prism.css" rel="Stylesheet">
<link type="text/css" href="default.css" rel="Stylesheet">
<script type="text/javascript" src="polyfills.js"></script><script type="text/javascript" src="languages.js"></script><script type="text/javascript" src="en-US/langnames.js"></script><script type="text/javascript" src="flexsearch.debug.js"></script><script type="text/javascript" src="prism.js"></script><script type="text/javascript" src="help2.js" defer></script><script type="text/javascript" src="a11y-toggle.js" defer></script><script type="text/javascript" src="paginathing.js" defer></script><script type="text/javascript" src="en-US/bookmarks.js" defer></script><script type="text/javascript" src="en-US/contents.js" defer></script><script type="text/javascript" src="help.js" defer></script><meta name="viewport" content="width=device-width,initial-scale=1">
</head>
<body>
<header id="TopLeftHeader"><a class="symbol" href="en-US/text/shared/05/new_help.html"><div></div></a><a class="logo" href="en-US/text/shared/05/new_help.html"><p dir="auto">LibreOffice 24.2 Help</p></a><div class="dropdowns"><div class="modules">
<button type="button" data-a11y-toggle="modules-nav" id="modules" aria-haspopup="true" aria-expanded="false" aria-controls="modules-nav">Module</button><nav id="modules-nav" hidden=""></nav>
</div></div></header><aside class="leftside"><input id="accordion-1" name="accordion-menu" type="checkbox"><label for="accordion-1" dir="auto">Contents</label><div id="Contents" class="contents-treeview"></div></aside><div id="SearchFrame"><div id="Bookmarks">
<input id="search-bar" type="search" class="search" placeholder="Search in bookmarks for chosen module" dir="auto"><div class="nav-container" tabindex="0"><nav class="index" dir="auto"></nav></div>
</div></div>
<div id="DisplayArea" itemprop="softwareHelp" itemscope="true" itemtype="http://schema.org/SoftwareApplication">
<a name="datediff"></a>
<a name="bm_id6134830"></a>
<meta itemprop="keywords" content="DateDiff function">
<h1 id="par_idN10542" dir="auto">DateDiff Function</h1>
<p id="par_idN10546" class="paragraph" dir="auto">Returns the number of date or time intervals between two given date values.</p>
<div class="embedded">
<a name="functsyntax"></a>
<h3 id="hd_id061420171139089682" dir="auto">Syntax:</h3>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Click on text to copy to clipboard"><pre dir="auto"><code class="language-visual-basic line-numbers">
DateDiff (interval As String, date1 As Date, date2 As Date [, firstDayOfWeek As Integer [, firstWeekOfYear As Integer]]) As Double
</code></pre></div>
<h2 id="par_idN1064B" dir="auto">Return value:</h2>
<p id="par_idN1064F" class="paragraph" dir="auto">A number.</p>
<div class="embedded">
<a name="functparameters"></a>
<h3 id="hd_id061420171139084157" dir="auto">Parameters:</h3>
</div>
<p id="par_idN10656" class="paragraph" dir="auto"> <span class="emph">interval</span> - A string expression from the following table, specifying the date or time interval.</p>
<div class="embedded">
<a name="datetable"></a>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_idN10636" class="tableheadintable" dir="auto">interval (string value)</p>
</th>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_idN1063C" class="tableheadintable" dir="auto">Explanation</p>
</th>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10643" class="tablecontentintable" dir="auto">yyyy</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10649" class="tablecontentintable" dir="auto">Year</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10650" class="tablecontentintable" dir="auto">q</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10656" class="tablecontentintable" dir="auto">Quarter</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1065D" class="tablecontentintable" dir="auto">m</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10663" class="tablecontentintable" dir="auto">Month</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1066A" class="tablecontentintable" dir="auto">y</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10670" class="tablecontentintable" dir="auto">Day of year</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10677" class="tablecontentintable" dir="auto">w</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1067D" class="tablecontentintable" dir="auto">Weekday</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10684" class="tablecontentintable" dir="auto">ww</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1068A" class="tablecontentintable" dir="auto">Week of year</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10691" class="tablecontentintable" dir="auto">d</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10697" class="tablecontentintable" dir="auto">Day</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1069E" class="tablecontentintable" dir="auto">h</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106A4" class="tablecontentintable" dir="auto">Hour</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106AB" class="tablecontentintable" dir="auto">n</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106B1" class="tablecontentintable" dir="auto">Minute</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106B8" class="tablecontentintable" dir="auto">s</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106BE" class="tablecontentintable" dir="auto">Second</p>
</td>
</tr>
</table>
<br>
</div>
<p id="par_idN10664" class="paragraph" dir="auto"> <span class="emph">date1, date2</span> - The two date values to be compared.</p>
<div class="embedded">
<a name="DateLiterals"></a>
<p id="par_id151616083357363" class="paragraph" dir="auto">Date literals allow to specify unambiguous date variables that are independent from the current language. Literals are enclosed between hash signs <span class="literal">#</span>. Possible formats are:</p>
<ul itemprop="Unordered" itemscope="true" itemtype="http://schema.org/ItemList" dir="auto">
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id41616083766108" class="listitem" dir="auto"><span class="literal">#yyyy-mm-dd#</span></p>
</li>
<li itemprop="itemListElement" itemscope="true" itemtype="http://schema.org/ItemListUnordered" dir="auto">
<p id="par_id271616083874773" class="listitem" dir="auto"><span class="literal">#mm/dd/yyyy#</span></p>
</li>
</ul>
</div>
<a name="weekyear"></a>
<p id="par_idN1066A" class="paragraph" dir="auto"> <span class="emph">firstdayofweek</span>: An optional parameter that specifies the starting day of a week. </p>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_idN1067A" class="tableheadintable" dir="auto">firstdayofweek value</p>
</th>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_idN10680" class="tableheadintable" dir="auto">Explanation</p>
</th>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10687" class="tablecontentintable" dir="auto">0</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1068D" class="tablecontentintable" dir="auto">Use system default value</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10694" class="tablecontentintable" dir="auto">1</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1069A" class="tablecontentintable" dir="auto">Sunday (default)</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106A1" class="tablecontentintable" dir="auto">2</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106A7" class="tablecontentintable" dir="auto">Monday</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106AE" class="tablecontentintable" dir="auto">3</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106B4" class="tablecontentintable" dir="auto">Tuesday</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106BB" class="tablecontentintable" dir="auto">4</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106C1" class="tablecontentintable" dir="auto">Wednesday</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106C8" class="tablecontentintable" dir="auto">5</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106CE" class="tablecontentintable" dir="auto">Thursday</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106D5" class="tablecontentintable" dir="auto">6</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106DB" class="tablecontentintable" dir="auto">Friday</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106E2" class="tablecontentintable" dir="auto">7</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN106E8" class="tablecontentintable" dir="auto">Saturday</p>
</td>
</tr>
</table>
<br>
<p id="par_idN106EB" class="paragraph" dir="auto"> <span class="emph">firstweekofyear</span>: An optional parameter that specifies the starting week of a year. </p>
<table border="1" class="" cellpadding="0" cellspacing="0">
<tr>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_idN106FB" class="tableheadintable" dir="auto">firstweekofyear value</p>
</th>
<th rowspan="" colspan="" class="tableheadcell" dir="auto">
<p id="par_idN10701" class="tableheadintable" dir="auto">Explanation</p>
</th>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10708" class="tablecontentintable" dir="auto">0</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1070E" class="tablecontentintable" dir="auto">Use system default value</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10715" class="tablecontentintable" dir="auto">1</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1071B" class="tablecontentintable" dir="auto">Week 1 is the week with January, 1st (default)</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10722" class="tablecontentintable" dir="auto">2</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10728" class="tablecontentintable" dir="auto">Week 1 is the first week containing four or more days of that year</p>
</td>
</tr>
<tr>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN1072F" class="tablecontentintable" dir="auto">3</p>
</td>
<td rowspan="" colspan="" dir="auto">
<p id="par_idN10735" class="tablecontentintable" dir="auto">Week 1 is the first week containing only days of the new year</p>
</td>
</tr>
</table>
<br>
<div class="embedded">
<a name="functexample"></a>
<h3 id="hd_id061420171139088233" dir="auto">Example:</h3>
</div>
<div class="bascode" itemscope="true" itemtype="http://schema.org/SoftwareSourceCode" itemprop="codeSampleType" content="snippet" data-tooltip="Click on text to copy to clipboard"><pre dir="auto"><code class="language-visual-basic line-numbers">
Sub example_datediff
MsgBox DateDiff("d", #1/1/2005#, #2005-12-31#)
End Sub
</code></pre></div>
</div>
<div id="DonationFrame"></div>
<footer><div id="DEBUG" class="debug">
<h3 class="bug">Help content debug info:</h3>
<p dir="auto">This page is: <a href="https://opengrok.libreoffice.org/xref/help/source/text/sbasic/shared/03030120.xhp" target="_blank">/text/sbasic/shared/03030120.xhp</a></p>
<p dir="auto">Title is: DateDiff Function</p>
<p id="bm_module" dir="auto"></p>
<p id="bm_system" dir="auto"></p>
<p id="bm_HID" dir="auto"></p>
</div></footer>
</body>
</html>